insert overwrite table spmi_dwd.dwd_ibk_account_history_base_dt partition(dt)
select
id,
account_id,
account_no,
network_id,
network_code,
network_name,
financial_center_id,
financial_center_code,
financial_center_name,
manage_region_code,
manage_region_name,
cfinancial_center_id,
cfinancial_center_code,
cfinancial_center_name,
amount,
close_amount,
warn_amount,
support_amount,
deposit_join,
deposit_quality,
daily_withdraw_limit,
daily_transfer_limit,
finance_manager,
finance_manager_mobile,
account_name,
account_bank,
account_bankno,
create_account_time,
create_network_id,
create_network_name,
update_network_id,
update_network_name,
remark,
password,
is_init,
is_enable,
is_delete,
create_by,
update_by,
create_by_name,
update_by_name,
record_time,
create_time,
update_time,
`version`,
`sort`,
tpye_id,
days_arrears,
use_amount,
franchisee_id,
franchisee_code,
franchisee_name,
is_suspend,
biz_update_time,
dt
from spmi_ods.ibk_account_history
where dt= '{{ execution_date | cst_ds }}'
distribute by dt
;
